You are here: Revised Table Definitions > FO_CDC_Outbound_Filter

FO_CDC_Outbound_Filter

This table allows the site to specify which types of records would be valid outbound via the Client Data Concentrator Outbound interfaces (CDCOut). The filtering can be done for a specific qualifier or for a qualifier-client code combination.

 

Field

Type

Notes

FilterID

int

Identity (counter) field

MPIQualifier

varchar(50)

Valid MPI qualifier code that accepts inbound messages.

ClientCode

varchar(50)

Valid client code or asterisk (*) for all clients

SendOrder

bit

Bit field to determine if order messages are sent on CDCOutbound.

0 = filter order messages, do not send

1 = send order messages

SendReceipt

bit

Bit field to determine if receipt order messages are sent on CDCOutbound.

0 = filter receipt order messages, do not send

1 = send receipt order messages

SendCancel

bit

Bit field to determine if cancel order messages are sent on CDCOutbound.

0 = filter cancel order messages, do not send

1 = send cancel order messages

SendNA

bit

Bit field to determine if SN/NA messages are sent on CDCOutbound.

0 = filter SN/NA messages, do not send

1 = send SN/NA messages

OrderControl

varchar(2)

Order control code used with SENDNA option.

EditDate

datetime

Date record was edited. Informational

EditUser

varchar(50)

User who last edited record. Informational

CreateDate

datetime

Date record was created. Informational

CreateUser

varchar(50)

User who created record. Informational